Tweet
Bonjour à tous
Et bien voilà mon site est planté je ne suis pas le premier et surement pas le dernier.
Après le passage impossible de 1.5 à 2.5 j'ai du reécrire tout mon site, je commence à saturer de ces mises à jour à répétition.
Après avoir lancé le processus j'ai eu le message suivant
erreur 1054 Table 'bridgeclwalenc.bridge_banners' doesn't exist SQL=ALTER TABLE `bridge_banners` ENGINE=InnoDB;
J'ai encore le backend mais ce texte en frontend
1054 - Unknown column 'c.version' in 'field list' SQL=SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM bridge_categories as c LEFT JOIN bridge_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM bridge_categories AS cat JOIN bridge_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=2 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft
Je pense savoir aller dans phpmyadmin créer cette table si besoin mais combien de colonnes etc... je ne sais pas?
Merci d'avance à ceux qui viendront à mon secours
Jean
Et bien voilà mon site est planté je ne suis pas le premier et surement pas le dernier.
Après le passage impossible de 1.5 à 2.5 j'ai du reécrire tout mon site, je commence à saturer de ces mises à jour à répétition.
Après avoir lancé le processus j'ai eu le message suivant
erreur 1054 Table 'bridgeclwalenc.bridge_banners' doesn't exist SQL=ALTER TABLE `bridge_banners` ENGINE=InnoDB;
J'ai encore le backend mais ce texte en frontend
1054 - Unknown column 'c.version' in 'field list' SQL=SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM bridge_categories as c LEFT JOIN bridge_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM bridge_categories AS cat JOIN bridge_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=2 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft
Je pense savoir aller dans phpmyadmin créer cette table si besoin mais combien de colonnes etc... je ne sais pas?
Merci d'avance à ceux qui viendront à mon secours
Jean
Commentaire